USE master;
GO
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'HumanResources')
	DROP DATABASE HumanResources
GO
CREATE DATABASE HumanResources;
GO
USE HumanResources;
GO
CREATE SCHEMA hr;
GO
CREATE TABLE hr.Employees
(
	EmployeeID INT NOT NULL,
	FirstName NVARCHAR(50) NOT NULL,
	LastName NVARCHAR(50) NOT NULL,
	JobTitle NVARCHAR(50) NOT NULL,
	EmailAddress NVARCHAR(50) NULL,
	City NVARCHAR(50) NOT NULL,
	StateProvinceName NVARCHAR(50) NOT NULL,
	CountryRegionName NVARCHAR(50) NOT NULL
)
